Overview
The Employee Sales Statistics Report shows a number of values against each employee for a day, or summarized for a week. The purpose of the Employee Sales Statistics Report is to provide statistics for the support of managing salespersons' performance.
See below for the values and their calculations.
Custom terminology allows you to define the retail terminology used within your business. Once defined, terminology automatically appears on criteria forms and reports. For more information on defining custom terminology refer to the article Custom Terminology.
Criteria Form
Refer to the article Report Criteria Form Standard Field Operation for help with the standard criteria form fields.
The following table describes the operation of non-standard fields where appropriate.
Field | Description |
---|---|
Report Format | This drop-down box decides the type of report to be generated. Following values are the options included from the list. Depending on the selection made here, additional fields will be activated or inactivated. |
Store | This drop-down box allows you to select the store. It is only activated when particular report formats have been selected. |
Store Sub Region | This drop-down box allows you to select a sub region. It is only activated when region report formats have been selected. |
Week Ending |
This field allows you to select a week ending date. It is a mandatory field to be entered.
|
Employee List | It provides an option to generate particular employee or All employees to generate the report. |
Reports
Refer to the section Understanding the Intelligence Store Data for help with the standard values included in Retail Arena reporting.
The following table describes non-standard columns where appropriate.
The following values are shown on the report. The report may be grouped by employee, or shown by employee for each day.Value | Description |
---|---|
Budget Sales | The target sales as calculated by proportioning the store daily target by the employee selling hours. |
Hours Worked | The total number of hours the employee worked; i.e. sum(Finish-Start-Breaks) |
Selling Hours | The number of selling hours; i.e. Hours Worked - Adjustments[Deduct] + Adjustments[Add] (see Staff Performance Management for a detailed explanation on adjustments) |
Total Sales $ | The total value of all sales made by this employee. |
Sales % Budget | The percentage of sales over the target sales. 100% or above would mean the employee reached their target. |
Less Returns $ | If the client adds back returns, the returns $ value will represent the total value of sales returned by customers. |
NETT SALES | The total sales value less returns. |
No of Transactions | The number of transactions made by the employee. |
Total no of Lines | The total number of lines on transactions. |
Avg Sale | The average value of a sale; this is calculated by Total Sales $ / No of Transactions. |
Items per Trans | The average number of lines on a transaction (Total No of Lines / No of Transactions). |
Remarks
Technical Reference
This section contains technical information about the various source objects for this report and parameters and customization that affect the reports operation. Refer to the article Form Customization and Parameters to understand how parameters, form customization, and security settings affect report and report criteria form operations.
Property | Value |
Form Name | ret_EmployeeSalesStatistics |
Form Customization JScript File Name | n/a |
Report Definition Name | ret_EmployeeSalesStatistics |
Permission Name | ret_EmployeeSalesStatistics |
Property | Value |
RDL Name | n/a |
Stored Procedure Name | n/a |
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | No |
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | No |
Supports Currency Conversion | No |
Honours the System::AggregateSalesIncludeNonInventory parameter. | No |
Honours the System::SalesAndTargetsIncludeTax parameter. | Yes |
Honours the System::UseConcessionStoreSales parameter. | No |
Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
Uses the LiveDataViews::Current_Stock parameter. |
No |